CREATE TABLE [dbo].[UniformLink]
(
[UniformLinkKey] [uniqueidentifier] NOT NULL,
[SystemEntityKey] [uniqueidentifier] NOT NULL,
[SubjectUniformKey] [uniqueidentifier] NOT NULL,
[TargetUniformKey] [uniqueidentifier] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[UniformLink] ADD CONSTRAINT [PK_UniformLink] PRIMARY KEY CLUSTERED ([UniformLinkKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_UniformLink_SubjectUniformKey] ON [dbo].[UniformLink] ([SubjectUniformKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_UniformLink_SystemEntityKey] ON [dbo].[UniformLink] ([SystemEntityKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_UniformLink_TargetUniformKey] ON [dbo].[UniformLink] ([TargetUniformKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UniformLink] ADD CONSTRAINT [FK_UniformLink_SystemEntity] FOREIGN KEY ([SystemEntityKey]) REFERENCES [dbo].[SystemEntity] ([SystemEntityKey])
GO
ALTER TABLE [dbo].[UniformLink] ADD CONSTRAINT [FK_UniformLink_UniformRegistry_Subject] FOREIGN KEY ([SubjectUniformKey]) REFERENCES [dbo].[UniformRegistry] ([UniformKey])
GO
ALTER TABLE [dbo].[UniformLink] ADD CONSTRAINT [FK_UniformLink_UniformRegistry_Target] FOREIGN KEY ([TargetUniformKey]) REFERENCES [dbo].[UniformRegistry] ([UniformKey])
GO